<!DOCTYPE html>
<html class="client-nojs vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-0 vector-toc-not-available vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-0 vector-feature-night-mode-enabled skin-theme-clientpref-os vector-sticky-header-enabled" lang="fr" dir="ltr"><head>
<meta charset="UTF-8">
<title>Object Query Language</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="icon" type="image/png" href="./_res_/favicon.png">
<link rel="canonical" href="https://fr.wikipedia.org/wiki/Object_Query_Language"> <link href="./_mw_/ext.cite.styles.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.pygments.css" rel="stylesheet" type="text/css">
<link href="./_mw_/ext.wikimediamessages.styles.css" rel="stylesheet" type="text/css">
<link href="./_mw_/skins.vector.icons.css" rel="stylesheet" type="text/css">
<link href="./_mw_/skins.vector.search.codex.styles.css" rel="stylesheet" type="text/css">
<link href="./_mw_/skins.vector.styles.css" rel="stylesheet" type="text/css">
<meta name="ResourceLoaderDynamicStyles" content="">
<link rel="stylesheet" type="text/css" href="./_mw_/site.styles.css">
<link rel="stylesheet" type="text/css" href="./_mw_/noscript.css">
<link rel="stylesheet" type="text/css" href="./_res_/footer.css">
<link rel="stylesheet" type="text/css" href="./_res_/vector-2022.css">
</head>
<body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject page-Object_Query_Language rootpage-Object_Query_Language skin-vector-2022 action-view">
<div class="mw-page-container">
<div class="mw-page-container-inner">
<div class="mw-content-container">
<main id="content" class="mw-body">
<header class="mw-body-header vector-page-titlebar">
<h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-main">Object Query Language</span></h1>
</header>
<a id="top"></a>
<div id="bodyContent" class="vector-body ve-init-mw-desktopArticleTarget-targetContainer" aria-labelledby="firstHeading" data-mw-ve-target-container="">
<div id="contentSub">
<div id="mw-content-subtitle"></div>
</div>
<div id="mw-content-text" class="mw-body-content mw-content-ltr" lang="fr" dir="ltr"><div class="mw-content-ltr mw-parser-output" lang="fr" dir="ltr"><p><b>Object Query Language</b> est une extension du langage <a href="Structured_Query_Language" title="Structured Query Language">SQL</a> pour <a href="Base_de_donn%C3%A9es_orient%C3%A9e_objet" title="Base de données orientée objet">base de données orientée objet</a>, langage de requête utilisé pour interroger des <a href="SGBDO" class="mw-redirect" title="SGBDO">SGBDO</a>, normalisé par l'<a href="ODMG" class="mw-redirect" title="ODMG">ODMG</a><sup id="cite_ref-1" class="reference"><a href="#cite_note-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup>.
</p><p>Ce langage est typé (les requêtes retournent des objets), et utilise les règles du <a href="Polymorphisme_(informatique)" title="Polymorphisme (informatique)">polymorphisme</a>.
</p>
<div class="mw-heading mw-heading2"><h2 id="Exemple">Exemple</h2></div>
<p>Moyenne de la capacité de la RAM des PC de la base, par constructeur :
</p>
<div class="mw-highlight mw-highlight-lang-sql mw-content-ltr" dir="ltr"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">manufacturer</span><span class="p">,</span><span class="w"> </span><span class="k">AVG</span><span class="p">(</span><span class="k">SELECT</span><span class="w"> </span><span class="n">part</span><span class="p">.</span><span class="n">pc</span><span class="p">.</span><span class="n">ram</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">partition</span><span class="w"> </span><span class="n">part</span><span class="p">)</span>
<span class="k">FROM</span><span class="w"> </span><span class="n">PCs</span><span class="w"> </span><span class="n">pc</span>
<span class="k">GROUP</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="n">manufacturer</span><span class="p">:</span><span class="w"> </span><span class="n">pc</span><span class="p">.</span><span class="n">manufacturer</span><span class="p">;</span>
</pre></div>
<div class="mw-heading mw-heading2"><h2 id="Références"><span id="R.C3.A9f.C3.A9rences"></span>Références</h2></div>
<div class="references-small decimal" style=""><div class="mw-references-wrap"><ol class="references">
<li id="cite_note-1"><span class="mw-cite-backlink"><a href="#cite_ref-1">↑</a> </span><span class="reference-text"><span class="ouvrage" id="by_R._G.G._Cattell,_Douglas_K._Barry,_Mark_Berler,_Jeff_Eastman,David_Jordan,_Craig_Russell,_Olaf_Schadow,_Torsten_Stanienda,_and_Fernando_Velez2000"><span class="ouvrage" id="Edited_by_R._G.G._Cattell,_Douglas_K._Barry,_Mark_Berler,_Jeff_Eastman,David_Jordan,_Craig_Russell,_Olaf_Schadow,_Torsten_Stanienda,_and_Fernando_Velez2000"><abbr class="abbr indicateur-langue" title="Langue : anglais">(en)</abbr> Edited by R. G.G. Cattell, Douglas K. Barry, Mark Berler, Jeff Eastman,David Jordan, Craig Russell, Olaf Schadow, Torsten Stanienda, and Fernando Velez, <cite class="italique" lang="en">The Object Data Management Standard: ODMG 3.0</cite>, Morgan Kaufmann, <time>2000</time> <small style="line-height:1em;">(<a href="International_Standard_Book_Number" title="International Standard Book Number">ISBN</a> <span class="nowrap">1-55860-647-5</span>)</small><span class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=The+Object+Data+Management+Standard%3A+ODMG+3.0&rft.pub=Morgan+Kaufmann&rft.au=Edited+by+R.+G.G.+Cattell%2C+Douglas+K.+Barry%2C+Mark+Berler%2C+Jeff+Eastman%2CDavid+Jordan%2C+Craig+Russell%2C+Olaf+Schadow%2C+Torsten+Stanienda%2C+and+Fernando+Velez&rft.date=2000&rft.isbn=1-55860-647-5&rfr_id=info%3Asid%2Ffr.wikipedia.org%3AObject+Query+Language"></span></span></span></span>
</li>
</ol></div>
</div>
<div class="mw-heading mw-heading2"><h2 id="Voir_aussi">Voir aussi</h2></div>
<ul><li>Object Definition Language <a href="https://ja.wikipedia.org/wiki/%E3%82%AA%E3%83%96%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88%E5%AE%9A%E7%BE%A9%E8%A8%80%E8%AA%9E" class="extiw external" title="ja:オブジェクト定義言語"><span class="indicateur-langue" title="Article en japonais : « オブジェクト定義言語 »">(ja)</span></a></li></ul>
<ul id="bandeau-portail" class="bandeau-portail"><li><span class="bandeau-portail-element"><span class="bandeau-portail-icone"><span class="noviewer" typeof="mw:File"></span></span> <span class="bandeau-portail-texte">Portail de la programmation informatique</span> </span></li> <li><span class="bandeau-portail-element"><span class="bandeau-portail-icone"><span class="noviewer" typeof="mw:File"></span></span> <span class="bandeau-portail-texte">Portail des bases de données</span> </span></li> </ul></div><!--htdig_noindex--><div><div class="zim-footer">
Cet article est issu de <a class="external text" title="Dernière modification le 2024-08-12" href="https://fr.wikipedia.org/wiki/?title=Object_Query_Language&oldid=217629546">Wikipédia</a>. Sauf mention contraire, le texte est disponible sous <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.fr">Creative Commons Attribution-Share Alike 4.0</a>. Des conditions supplémentaires peuvent s’appliquer aux fichiers multimédias.
</div>
</div><!--/htdig_noindex--></div>
</div>
</main>
</div>
</div>
</div>
<script src="./_webp_/webpHandler.js"></script>
</body></html>